INSERT INTO MeterLocationLine SELECT DISTINCT MeterLocationID, LineID FROM MeterLine JOIN Meter ON MeterLine.MeterID = Meter.ID WHERE NOT EXISTS ( SELECT * FROM MeterLocationLine WHERE MeterLocationID = Meter.MeterLocationID AND LineID = MeterLine.LineID )